Retrieve Rates Using Extension Framework

When OICE encounters a RATE or RATEARRAY math variable type, it executes one of three access methods. Accessing rates through an extension framework is one of those retrieval methods. The property rateRetriever.className allows an extension to access rates. The property identifies the extension by its fully qualified class name. OICE passes parameter information to the designated extension. The extension may return one rate or multiple rates as a result of the RateGroup's structure and the parameters provided by the RATE or RATEARRAY math variables. If the appropriate result is not returned, an exception will be thrown.

 

Refer to the 9.7.0.0 Documentation library on OTN  for a complete explanation of this property.

Modifications to the System Properties file requires a restart of the application.

Configuration Steps

  1. Define rate table. Rate tables can be user-defined tables stored in the AsRate and AsRateGroup database tables. Alternatively, they can be custom tables stored internally on OICE or externally and accessed by stored procedures.
  2. Make sure the System Properties file has the stored procedure property rateRetriever.classNameproperly defined.

    RATE and RATEARRAY can be used with stored procedures and/or extension framework.

  1. Use a fully qualified class name.
  2. Define Input and Output parameters.

 

Execution errors

If a class name does not exist when OICE attempts to process rates, then an error will be logged and processing will continue using the default method.

 

If a bad parameter is passed, then an exception will be generated.

 

 

Copyright © 2009, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices